<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>

<div class="content">
                    <sql:query var="rs" dataSource="jdbc/bookzone">
                        select BOOKS.*, PRICES.book_price FROM BOOKS JOIN PRICES ON BOOKS.book_id = PRICES.book_id
                    </sql:query>

                    <c:forEach var="row" items="${rs.rows}">
                        <div class="bookItem">
                            <div class="productImage"><img src="${row.img_url}" border="0"/></div>
                            <div class="productData">
                                <div class="productTitle">
                                    <a href="/details.jsp?product_id=${row.book_id}">${row.title}</a>
                                    <span class="authors">${row.author1}</span>
                                </div>
                            </div>
                        </div>

                        <br clear="all">
                    </c:forEach>
                </div>